exports.path = '/example/plsqlBind';
exports.title = '调用plsql绑定输入输出参数范例';
exports.pool = 'task';

exports.sqltext = `
begin
  if :xxx is not null then
    :yyyOut := 1;
  else
    :yyyOut := 2;
  end if;

  if :type = 'table' then
    open :dictCur for select * from user_tables where rownum <= 3;
  elsif :type = 'index' then
    open :dictCur for select * from user_indexes where rownum <= 3;
  end if;
end;
`;

exports.request = {};
